1 <?php
2 error_reporting(0);
3 require("../includes/config.php");
4 include("../includes/validate_data.php");
5 session_start();
6 if(isset($_SESSION['manufacturer_login'])) {
7 $error = "";
8 $querySelectRetailer = "SELECT *,area.area_id AS area_id FROM retailer,area WHERE retailer.area_id = area.area_id";
9 $resultSelectRetailer = mysqli_query($con,$querySelectRetailer);
10 if($_SERVER['REQUEST_METHOD'] == "POST") {
11 if(isset($_POST['cmbFilter'])) {
12 if(!empty($_POST['txtInvoiceId'])) {
13 $result = validate_number($_POST['txtInvoiceId']);
14 if($result == 1) {
15 $invoice_id = $_POST['txtInvoiceId'];
16 $query_selectInvoice = "SELECT * FROM invoice,retailer,area WHERE invoice.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND invoice_id='$invoice_id'";
17 $result_selectInvoice = mysqli_query($con,$query_selectInvoice);
18 $row_selectInvoice = mysqli_fetch_array($result_selectInvoice);
19 if(empty($row_selectInvoice)){
20 $error = "* No invoice was found with this ID";
21 }
22 else {
23 mysqli_data_seek($result_selectInvoice,0);
24 }
25 }
26 else {
27 $error = "* Invalid ID";
28 }
29 }
30 else if(!empty($_POST['txtOrderId'])) {
31 $result = validate_number($_POST['txtOrderId']);
32 if($result == 1) {
33 $order_id = $_POST['txtOrderId'];
34 $query_selectInvoice = "SELECT * FROM invoice,retailer,area WHERE invoice.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND order_id='$order_id'";
35 $result_selectInvoice = mysqli_query($con,$query_selectInvoice);
36 $row_selectInvoice = mysqli_fetch_array($result_selectInvoice);
37 if(empty($row_selectInvoice)){
38 $error = "* No invoice was found with this ID";
39 }
40 else {
41 mysqli_data_seek($result_selectInvoice,0);
42 }
43 }
44 else {
45 $error = "* Invalid ID";
46 }
47 }
48 else if(!empty($_POST['cmbRetailer'])) {
49 $retailer_id = $_POST['cmbRetailer'];
50 $query_selectInvoice = "SELECT * FROM invoice,retailer,area WHERE invoice.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND invoice.retailer_id='$retailer_id' ORDER BY invoice_id DESC";
51 $result_selectInvoice = mysqli_query($con,$query_selectInvoice);
52 $row_selectInvoice = mysqli_fetch_array($result_selectInvoice);
53 if(empty($row_selectInvoice)){
54 $error = "* No invoice was found of the selected Retailer";
55 }
56 else {
57 mysqli_data_seek($result_selectInvoice,0);
58 }
59 }
60 else if(!empty($_POST['txtDate'])) {
61 $date = $_POST['txtDate'];
62 $query_selectInvoice = "SELECT * FROM invoice,retailer,area WHERE invoice.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id AND invoice.date='$date'";
63 $result_selectInvoice = mysqli_query($con,$query_selectInvoice);
64 $row_selectInvoice = mysqli_fetch_array($result_selectInvoice);
65 if(empty($row_selectInvoice)){
66 $error = "* No invoice was found with the selected Date";
67 }
68 else {
69 mysqli_data_seek($result_selectInvoice,0);
70 }
71
72 }
73 else {
74 $error = "* Please enter the data to search for.";
75 }
76 }
77 else {
78 $error = "Please choose an option to search for.";
79 }
80 }
81 else {
82 $query_selectInvoice = "SELECT * FROM invoice,retailer,area WHERE invoice.retailer_id=retailer.retailer_id AND retailer.area_id=area.area_id";
83 $result_selectInvoice = mysqli_query($con,$query_selectInvoice);
84 }
85 }
86 else {
87 header('Location:../index.php');
88 }
89 ?>
90
91 <!DOCTYPE html>
92 <html>
93 <head>
94 <title> View Invoices </title>
95 <link rel="stylesheet" href="../includes/main_style.css" >
96 <link rel="stylesheet" href="css/smoothness/jquery-ui.css">
97 <script type="text/javascript" src="../includes/jquery.js"> </script>
98 <script src="js/jquery-ui.js"></script>
99 <script>
100 $(function() {
101 $( "#datepicker" ).datepicker({
102 changeMonth:true,
103 changeYear:true,
104 yearRange:"-100:+0",
105 dateFormat:"yy-mm-dd"
106 });
107 });
108 </script>
109 </head>
110 <body>
111 <?php
112 include("../includes/header.inc.php");
113 include("../includes/nav_manufacturer.inc.php");
114 include("../includes/aside_manufacturer.inc.php");
115 ?>
116 <section>
117 <h1>Invoices</h1>
118 <form action="" method="POST" class="form">
119 Search By:
120 <div class="input-box">
121 <select name="cmbFilter" id="cmbFilter">
122 <option value="" disabled selected>-- Search By --</option>
123 <option value="invoiceId"> Invoice Id </option>
124 <option value="orderId"> Order ID </option>
125 <option value="retailer"> Retailer </option>
126 <option value="date"> Date </option>
127 </select>
128 </div>
129
130 <div class="input-box"> <input type="text" name="txtInvoiceId" id="txtInvoiceId" style="display:none;" /> </div>
131 <div class="input-box"> <input type="text" name="txtOrderId" id="txtOrderId" style="display:none;" /> </div>
132 <div class="input-box">
133 <select name="cmbRetailer" id="cmbRetailer" style="display:none;">
134 <option value="" disabled selected>-- Select Retailer --</option>
135 <?php while($rowSelectRetailer = mysqli_fetch_array($resultSelectRetailer)) { ?>
136 <option value="<?php echo $rowSelectRetailer['retailer_id']; ?>"><?php echo $rowSelectRetailer['area_code']." (".$rowSelectRetailer['area_name'].")"; ?></option>
137 <?php } ?>
138 </select>
139 </div>
140 <div class="input-box"> <input type="text" id="datepicker" name="txtDate" style="display:none;"/> </div>
141 <input type="submit" class="submit_button" value="Search" /> <span class="error_message"> <?php echo $error; ?> </span>
142 </form>
143
144 <form action="" method="POST" class="form">
145 <table class="table_displayData" style="margin-top:20px;">
146 <tr>
147 <th> Invoice ID </th>
148 <th> Retailer </th>
149 <th> Date </th>
150 <th> Order ID </th>
151 <th> Total Amount </th>
152 <th> Details </th>
153 </tr>
154 <?php while($row_selectInvoice = mysqli_fetch_array($result_selectInvoice)) { ?>
155 <tr>
156
157 <td> <?php echo $row_selectInvoice['invoice_id']; ?> </td>
158 <td> <?php echo $row_selectInvoice['area_code']; ?> </td>
159
160 <td> <?php echo date("d-m-Y",strtotime($row_selectInvoice['date'])); ?> </td>
161 <td> <?php echo $row_selectInvoice['order_id']; ?> </td>
162 <td> <?php echo $row_selectInvoice['total_amount']; ?> </td>
163 <td> <a href="view_invoice_items.php?id=<?php echo $row_selectInvoice['invoice_id']; ?>">Details</a> </td>
164 </tr>
165 <?php } ?>
166 </table>
167 </form>
168 </section>
169 <?php
170 include("../includes/footer.inc.php");
171 ?>
172 <script type="text/javascript">
173 $('#cmbFilter').change(function() {
174 var selected = $(this).val();
175 if(selected == "invoiceId"){
176 $('#txtInvoiceId').show();
177 $('#txtOrderId').hide();
178 $('#datepicker').hide();
179 $('#cmbRetailer').hide();
180 }
181 else if (selected == "orderId"){
182 $('#txtInvoiceId').hide();
183 $('#txtOrderId').show();
184 $('#datepicker').hide();
185 $('#cmbRetailer').hide();
186 }
187 else if (selected == "retailer"){
188 $('#txtInvoiceId').hide();
189 $('#txtOrderId').hide();
190 $('#datepicker').hide();
191 $('#cmbRetailer').show();
192 }
193 else if (selected == "date"){
194 $('#txtInvoiceId').hide();
195 $('#txtOrderId').hide();
196 $('#datepicker').show();
197 $('#cmbRetailer').hide();
198 }
199 });
200 </script>
201 </body>
202 </html>